<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<%@ taglib prefix="f" uri="http://java.sun.com/jsf/core"%>
<%@ taglib prefix="h" uri="http://java.sun.com/jsf/html"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>User Main Menu</title>
</head>
<body bgcolor="#99CCFF">
	<f:view>
		<center>
			<h:form>
				<h:panelGrid columns="4">
					<h:commandButton type="submit" value="Home"
						action="index?faces-redirect=true" />
					<h:commandButton type="submit" value="Import Worksheet"
						action="fileImport?faces-redirect=true" />
					<h:commandButton type="submit" value="Export Worksheet"
						action="#{actionBeanDatabaseAccess.exportWorksheet}" />
					<h:commandButton type="submit" value="Logout"
						action="logout?faces-redirect=true" />
				</h:panelGrid>
			</h:form>
		</center>

		<br />
		<hr />
		<br />

		<h:outputText value="#{messageBean.errorMessage}" />
		<h:outputText value="#{messageBean.message}" />

		<h:panelGrid columns="2" rendered="#{dbaseBean.renderResult}">
			<h:outputText value="SQL query:" />
			<h:outputText value="#{dbaseBean.sqlQuery}" />
			<h:outputText value="Column names:" />
			<h:outputText value="#{dbaseBean.columnNames}" />
			<h:outputText value="Number of columns:" />
			<h:outputText value="#{dbaseBean.numberColumns}" />
			<h:outputText value="Number of rows:" />
			<h:outputText value="#{dbaseBean.numberRows}" />
		</h:panelGrid>

		<f:verbatim>
			<br />
			<hr />
			<br />
		</f:verbatim>
	</f:view>
</body>
</html>